/*
 Navicat Premium Data Transfer

 Source Server         : local
 Source Server Type    : MySQL
 Source Server Version : 80018
 Source Host           : localhost:3306
 Source Schema         : 学生成绩管理系统

 Target Server Type    : MySQL
 Target Server Version : 80018
 File Encoding         : 65001

 Date: 04/03/2021 11:41:03
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

DROP DATABASE IF EXISTS `学生成绩管理系统`;
CREATE DATABASE IF NOT EXISTS `学生成绩管理系统` DEFAULT CHARACTER SET = 'UTF8' ;
USE `学生成绩管理系统` ;

-- ----------------------------
-- Table structure for 学生信息
-- ----------------------------
DROP TABLE IF EXISTS `学生信息`;
CREATE TABLE `学生信息` (
  `学号` varchar(50) DEFAULT NULL,
  `姓名` varchar(50) DEFAULT NULL,
  `性别` varchar(10) DEFAULT NULL,
  `出生日期` date DEFAULT NULL,
  `民族` varchar(50) DEFAULT NULL,
  `所属班级` varchar(50) DEFAULT NULL,
  `家庭住址` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of 学生信息
-- ----------------------------
BEGIN;
INSERT INTO `学生信息` VALUES ('2005010101', '苏俊丹', '女', '1987-01-12', '汉族', '20050101', '河南商丘');
INSERT INTO `学生信息` VALUES ('2005010102', '张苗苗', '女', '1985-08-24', '汉族', '20050101', '河南洛阳');
INSERT INTO `学生信息` VALUES ('2005010201', '赵希坤', '女', '1985-10-15', '汉族', '20050102', '河南安阳');
INSERT INTO `学生信息` VALUES ('2005010202', '阮志婷', '女', '1988-04-25', '汉族', '20050102', '江西南昌');
INSERT INTO `学生信息` VALUES ('2005020101', '程丽婷', '女', '1985-03-27', '汉族', '20050201', '河南洛阳');
INSERT INTO `学生信息` VALUES ('2005020102', '戚正韦', '男', '1987-07-18', '回族', '20050201', '贵州贵阳');
INSERT INTO `学生信息` VALUES ('2005020201', '李家洋', '男', '1985-09-25', '汉族', '20050202', '四川成都');
INSERT INTO `学生信息` VALUES ('2005020202', '孟彬彬', '女', '1986-11-15', '汉族', '20050202', '四川成都');
INSERT INTO `学生信息` VALUES ('2005030101', '蔡莎莎', '女', '1985-07-13', '汉族', '20050301', '河南安阳');
INSERT INTO `学生信息` VALUES ('2005030102', '蔡金奎', '男', '1986-12-06', '汉族', '20050301', '江西南昌');
INSERT INTO `学生信息` VALUES ('2005040101', '陈亚克', '男', '1985-12-12', '汉族', '20050402', '宁夏银川');
INSERT INTO `学生信息` VALUES ('2005040102', '苏普秀', '女', '1985-02-26', '汉族', '20050402', '湖南长沙');
INSERT INTO `学生信息` VALUES ('2005040201', '蔡智勇', '男', '1985-12-26', '汉族', '20050402', '宁夏银川');
INSERT INTO `学生信息` VALUES ('2005040202', '侯志方', '女', '1986-05-19', '汉族', '20050402', '河南郑州');
INSERT INTO `学生信息` VALUES ('2005050101', '李明', '男', '1985-12-10', '汉族', '20050501', '山东济南');
INSERT INTO `学生信息` VALUES ('2005050102', '陈曦', '女', '1988-09-25', '汉族', '20050501', '湖北武汉');
INSERT INTO `学生信息` VALUES ('2005050201', '郑小营', '男', '1984-05-12', '汉族', '20050502', '湖北武汉');
INSERT INTO `学生信息` VALUES ('2005050202', '王静', '女', '1987-05-05', '汉族', '20050502', '山东济南');
INSERT INTO `学生信息` VALUES ('2005050206', '祝红涛', '男', '1984-08-25', '汉族', '20050502', '河南郑州');
COMMIT;

-- ----------------------------
-- Table structure for 成绩信息
-- ----------------------------
DROP TABLE IF EXISTS `成绩信息`;
CREATE TABLE `成绩信息` (
  `成绩编号` varchar(50) DEFAULT NULL,
  `学生编号` varchar(50) DEFAULT NULL,
  `考试编号` varchar(50) DEFAULT NULL,
  `课程编号` varchar(50) DEFAULT NULL,
  `分数` varchar(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of 成绩信息
-- ----------------------------
BEGIN;
INSERT INTO `成绩信息` VALUES ('3', '2005010101', '0801', '1', '89');
INSERT INTO `成绩信息` VALUES ('4', '2005010101', '0801', '2', '87');
INSERT INTO `成绩信息` VALUES ('5', '2005010102', '0801', '1', '82');
INSERT INTO `成绩信息` VALUES ('7', '2005010102', '0801', '2', '88');
INSERT INTO `成绩信息` VALUES ('8', '2005010101', '0802', '1', '96');
INSERT INTO `成绩信息` VALUES ('9', '2005010101', '0802', '2', '93');
INSERT INTO `成绩信息` VALUES ('13', '2005010102', '0802', '1', '89');
INSERT INTO `成绩信息` VALUES ('14', '2005010102', '0802', '2', '96');
INSERT INTO `成绩信息` VALUES ('15', '2005020101', '0801', '3', '85');
INSERT INTO `成绩信息` VALUES ('16', '2005020101', '0801', '4', '74');
INSERT INTO `成绩信息` VALUES ('17', '2005020102', '0801', '3', '78');
INSERT INTO `成绩信息` VALUES ('18', '2005020102', '0801', '4', '89');
INSERT INTO `成绩信息` VALUES ('19', '2005020101', '0802', '3', '95');
INSERT INTO `成绩信息` VALUES ('20', '2005020101', '0802', '4', '85');
INSERT INTO `成绩信息` VALUES ('21', '2005020102', '0802', '3', '79');
INSERT INTO `成绩信息` VALUES ('22', '2005020102', '0802', '4', '78');
INSERT INTO `成绩信息` VALUES ('24', '2005030101', '0801', '5', '89');
INSERT INTO `成绩信息` VALUES ('25', '2005030101', '0801', '6', '92');
INSERT INTO `成绩信息` VALUES ('26', '2005030101', '0802', '5', '85');
INSERT INTO `成绩信息` VALUES ('27', '2005030101', '0802', '6', '59');
INSERT INTO `成绩信息` VALUES ('28', '2005040201', '0801', '7', '62');
INSERT INTO `成绩信息` VALUES ('29', '2005040201', '0801', '8', '98');
INSERT INTO `成绩信息` VALUES ('30', '2005040202', '0801', '7', '84');
INSERT INTO `成绩信息` VALUES ('31', '2005040202', '0801', '8', '86');
INSERT INTO `成绩信息` VALUES ('32', '2005040201', '0802', '7', '90');
INSERT INTO `成绩信息` VALUES ('33', '2005040201', '0802', '8', '82');
INSERT INTO `成绩信息` VALUES ('34', '2005040202', '0802', '7', '62');
INSERT INTO `成绩信息` VALUES ('35', '2005040202', '0802', '8', '96');
INSERT INTO `成绩信息` VALUES ('36', '2005050101', '0801', '9', '95');
INSERT INTO `成绩信息` VALUES ('40', '2005050101', '0801', '10', '91');
INSERT INTO `成绩信息` VALUES ('41', '2005050102', '0801', '9', '80');
INSERT INTO `成绩信息` VALUES ('43', '2005050102', '0801', '10', '86');
INSERT INTO `成绩信息` VALUES ('44', '2005050101', '0802', '9', '80');
INSERT INTO `成绩信息` VALUES ('45', '2005050101', '0802', '10', '76');
INSERT INTO `成绩信息` VALUES ('46', '2005050102', '0802', '9', '95');
INSERT INTO `成绩信息` VALUES ('47', '2005050102', '0802', '10', '94');
INSERT INTO `成绩信息` VALUES ('50', '2005050201', '0801', '9', '96');
INSERT INTO `成绩信息` VALUES ('53', '2005050201', '0801', '10', '74');
INSERT INTO `成绩信息` VALUES ('54', '2005050202', '0801', '9', '89');
INSERT INTO `成绩信息` VALUES ('55', '2005050202', '0801', '10', '85');
INSERT INTO `成绩信息` VALUES ('56', '2005050201', '0802', '9', '75');
INSERT INTO `成绩信息` VALUES ('57', '2005050201', '0802', '10', '79');
INSERT INTO `成绩信息` VALUES ('58', '2005050202', '0802', '9', '96');
INSERT INTO `成绩信息` VALUES ('59', '2005050202', '0802', '10', '83');
INSERT INTO `成绩信息` VALUES ('60', '2005040101', '0801', '7', '85');
INSERT INTO `成绩信息` VALUES ('61', '2005040101', '0801', '8', '79');
INSERT INTO `成绩信息` VALUES ('62', '2005040102', '0801', '7', '98');
INSERT INTO `成绩信息` VALUES ('63', '2005040102', '0801', '8', '92');
INSERT INTO `成绩信息` VALUES ('64', '2005040101', '0802', '7', '81');
INSERT INTO `成绩信息` VALUES ('65', '2005040101', '0802', '8', '80');
INSERT INTO `成绩信息` VALUES ('66', '2005040102', '0802', '7', '81');
INSERT INTO `成绩信息` VALUES ('67', '2005040102', '0802', '8', '91');
INSERT INTO `成绩信息` VALUES ('68', '2005030102', '0801', '5', '95');
INSERT INTO `成绩信息` VALUES ('69', '2005030102', '0801', '6', '75');
INSERT INTO `成绩信息` VALUES ('70', '2005030102', '0802', '5', '85');
INSERT INTO `成绩信息` VALUES ('71', '2005030102', '0802', '6', '76');
INSERT INTO `成绩信息` VALUES ('72', '2005020201', '0801', '3', '85');
INSERT INTO `成绩信息` VALUES ('73', '2005020201', '0801', '4', '74');
INSERT INTO `成绩信息` VALUES ('74', '2005020202', '0801', '3', '56');
INSERT INTO `成绩信息` VALUES ('75', '2005020202', '0801', '4', '86');
INSERT INTO `成绩信息` VALUES ('76', '2005020202', '0802', '3', '86');
INSERT INTO `成绩信息` VALUES ('77', '2005020202', '0802', '4', '70');
INSERT INTO `成绩信息` VALUES ('78', '2005020201', '0802', '3', '75');
INSERT INTO `成绩信息` VALUES ('79', '2005020201', '0802', '4', '87');
INSERT INTO `成绩信息` VALUES ('80', '2005010201', '0801', '1', '83');
INSERT INTO `成绩信息` VALUES ('81', '2005010201', '0801', '2', '75');
INSERT INTO `成绩信息` VALUES ('82', '2005010201', '0802', '1', '79');
INSERT INTO `成绩信息` VALUES ('83', '2005010201', '0802', '2', '85');
INSERT INTO `成绩信息` VALUES ('84', '2005010202', '0801', '1', '89');
INSERT INTO `成绩信息` VALUES ('85', '2005010202', '0801', '2', '94');
INSERT INTO `成绩信息` VALUES ('87', '2005010202', '0802', '1', '92');
INSERT INTO `成绩信息` VALUES ('88', '2005010202', '0802', '2', '85');
INSERT INTO `成绩信息` VALUES ('93', '2005010101', '0802', '10', '85');
COMMIT;

-- ----------------------------
-- Table structure for 教师信息
-- ----------------------------
DROP TABLE IF EXISTS `教师信息`;
CREATE TABLE `教师信息` (
  `教师编号` varchar(50) DEFAULT NULL,
  `姓名` varchar(50) DEFAULT NULL,
  `性别` varchar(10) DEFAULT NULL,
  `年龄` varchar(10) DEFAULT NULL,
  `民族` varchar(10) DEFAULT NULL,
  `籍贯` varchar(50) DEFAULT NULL,
  `联系电话` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of 教师信息
-- ----------------------------
BEGIN;
INSERT INTO `教师信息` VALUES ('2005001', '孙鹏', '男', '28', '汉族', '河南郑州', '15862584953');
INSERT INTO `教师信息` VALUES ('20050010', '李玉英', '女', '54', '汉族', '河南安阳', '15846782943');
INSERT INTO `教师信息` VALUES ('20050011', '李曙光', '男', '31', '汉族', '陕西西安', '15945862664');
INSERT INTO `教师信息` VALUES ('20050012', '张西芝', '男', '29', '汉族', '贵州贵阳', '15894624923');
INSERT INTO `教师信息` VALUES ('20050013', '韩林林', '女', '25', '汉族', '安徽芜湖', '15918936549');
INSERT INTO `教师信息` VALUES ('20050014', '王卫东', '男', '38', '汉族', '陕西宝鸡', '15916981239');
INSERT INTO `教师信息` VALUES ('20050015', '郑帅', '男', '26', '汉族', '陕西西安', '15803754966');
INSERT INTO `教师信息` VALUES ('2005002', '马欢', '男', '32', '汉族', '山西太原', '15862359843');
INSERT INTO `教师信息` VALUES ('2005003', '崔建涛', '男', '35', '汉族', '江西南昌', '13545268156');
INSERT INTO `教师信息` VALUES ('2005004', '赵丹', '女', '26', '满族', '河南郑州', '13659261258');
INSERT INTO `教师信息` VALUES ('2005005', '马艳', '女', '36', '回族', '安徽芜湖', '13548946354');
INSERT INTO `教师信息` VALUES ('2005006', '周健', '男', '56', '汉族', '山西太原', '13549618796');
INSERT INTO `教师信息` VALUES ('2005007', '王宏', '女', '45', '回族', '福建厦门', '13549761548');
INSERT INTO `教师信息` VALUES ('2005008', '赵军涛', '男', '35', '汉族', '江西南昌', '15948963459');
INSERT INTO `教师信息` VALUES ('2005009', '王喜庆', '男', '46', '汉族', '河南安阳', '15915613479');
COMMIT;

-- ----------------------------
-- Table structure for 班级信息
-- ----------------------------
DROP TABLE IF EXISTS `班级信息`;
CREATE TABLE `班级信息` (
  `班级编号` varchar(50) DEFAULT NULL,
  `班级名` varchar(50) DEFAULT NULL,
  `班级人数` varchar(50) DEFAULT NULL,
  `所属系别` varchar(50) DEFAULT NULL,
  `辅导员` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of 班级信息
-- ----------------------------
BEGIN;
INSERT INTO `班级信息` VALUES ('20050101', '计算机科学与技术1班', '18', '200501', '03');
INSERT INTO `班级信息` VALUES ('20050102', '计算机科学与技术2班', '19', '200501', '03');
INSERT INTO `班级信息` VALUES ('20050201', '英语系1班', '21', '200502', '04');
INSERT INTO `班级信息` VALUES ('20050202', '英语系2班', '20', '200502', '06');
INSERT INTO `班级信息` VALUES ('20050301', '企业管理系1班', '19', '200503', '05');
INSERT INTO `班级信息` VALUES ('20050401', '国际贸易系1班', '18', '200504', '09');
INSERT INTO `班级信息` VALUES ('20050402', '国际贸易系2班', '20', '200504', '01');
INSERT INTO `班级信息` VALUES ('20050501', '艺术系1班', '26', '200505', '08');
INSERT INTO `班级信息` VALUES ('20050502', '艺术系2班', '21', '200505', '07');
COMMIT;

-- ----------------------------
-- Table structure for 系别信息
-- ----------------------------
DROP TABLE IF EXISTS `系别信息`;
CREATE TABLE `系别信息` (
  `系别编号` varchar(50) DEFAULT NULL,
  `系别名称` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of 系别信息
-- ----------------------------
BEGIN;
INSERT INTO `系别信息` VALUES ('200501', '计算机科学与技术系');
INSERT INTO `系别信息` VALUES ('200502', '外语系');
INSERT INTO `系别信息` VALUES ('200503', '企业管理系');
INSERT INTO `系别信息` VALUES ('200504', '国际贸易系');
INSERT INTO `系别信息` VALUES ('200505', '艺术系');
COMMIT;

-- ----------------------------
-- Table structure for 考试安排
-- ----------------------------
DROP TABLE IF EXISTS `考试安排`;
CREATE TABLE `考试安排` (
  `考试编号` varchar(50) DEFAULT NULL,
  `考试类型` varchar(50) DEFAULT NULL,
  `考试时间` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of 考试安排
-- ----------------------------
BEGIN;
INSERT INTO `考试安排` VALUES ('0801', '期中考试', '2008-11-01');
INSERT INTO `考试安排` VALUES ('0802', '期末考试', '2009-01-04');
COMMIT;

-- ----------------------------
-- Table structure for 课程信息
-- ----------------------------
DROP TABLE IF EXISTS `课程信息`;
CREATE TABLE `课程信息` (
  `课程编号` varchar(50) DEFAULT NULL,
  `课程名称` varchar(50) DEFAULT NULL,
  `任课教师` varchar(50) DEFAULT NULL,
  `是否必修` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of 课程信息
-- ----------------------------
BEGIN;
INSERT INTO `课程信息` VALUES ('1', '数据库管理', '20050014', '是');
INSERT INTO `课程信息` VALUES ('10', '图案与构成', '2005002', '否');
INSERT INTO `课程信息` VALUES ('11', '计算机网络', '20050013', '是');
INSERT INTO `课程信息` VALUES ('12', '新概念英语', '2005007', '否');
INSERT INTO `课程信息` VALUES ('13', '计算机操作系统', '20050010', '是');
INSERT INTO `课程信息` VALUES ('14', '心理学', '20050012', '否');
INSERT INTO `课程信息` VALUES ('15', '管理学', '20050015', '否');
INSERT INTO `课程信息` VALUES ('2', '高等数学', '2005001', '是');
INSERT INTO `课程信息` VALUES ('3', '大学英语', '2005006', '是');
INSERT INTO `课程信息` VALUES ('4', '外贸英语', '2005005', '是');
INSERT INTO `课程信息` VALUES ('5', '财务管理', '20050011', '是');
INSERT INTO `课程信息` VALUES ('6', '营销管理', '2005009', '是');
INSERT INTO `课程信息` VALUES ('7', '经济学基础', '2005003', '是');
INSERT INTO `课程信息` VALUES ('8', '管理信息系统', '2005008', '是');
INSERT INTO `课程信息` VALUES ('9', '装饰素描', '2005004', '是');
COMMIT;

-- ----------------------------
-- Table structure for 辅导员信息
-- ----------------------------
DROP TABLE IF EXISTS `辅导员信息`;
CREATE TABLE `辅导员信息` (
  `辅导员编号` varchar(50) DEFAULT NULL,
  `姓名` varchar(50) DEFAULT NULL,
  `性别` varchar(10) DEFAULT NULL,
  `年龄` varchar(10) DEFAULT NULL,
  `民族` varchar(50) DEFAULT NULL,
  `籍贯` varchar(50) DEFAULT NULL,
  `联系方式` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of 辅导员信息
-- ----------------------------
BEGIN;
INSERT INTO `辅导员信息` VALUES ('01', '曹丹丹', '女', '26', '汉族', '河南洛阳', '15926021546');
INSERT INTO `辅导员信息` VALUES ('02', '李磊', '男', '35', '汉族', '河南登封', '13569485986');
INSERT INTO `辅导员信息` VALUES ('03', '王艳', '女', '32', '满族', '云南大理', '15878952653');
INSERT INTO `辅导员信息` VALUES ('04', '张华', '女', '46', '汉族', '山东青岛', '15865291489');
INSERT INTO `辅导员信息` VALUES ('05', '王强', '男', '29', '回族', '河南郑州', '13959623579');
INSERT INTO `辅导员信息` VALUES ('06', '李锡', '男', '25', '汉族', '宁夏银川', '13595621635');
INSERT INTO `辅导员信息` VALUES ('07', '王宏敏', '女', '26', '汉族', '浙江杭州', '15816832266');
INSERT INTO `辅导员信息` VALUES ('08', '蔡莎莎', '女', '24', '汉族', '河南安阳', '15856139956');
INSERT INTO `辅导员信息` VALUES ('09', '周红颜', '女', '50', '汉族', '湖北武汉', '13156923953');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
